Future and Sale Price File - FIL 28

Description/Instructions

If your pricing is set up using the Price File, enter an existing price class code here. The program displays the pricing information for that price class, and then you can change it as needed.

If you enter a price class, you must also enter a price list number. Remember that each price class can have multiple price list numbers, each with their own pricing information. If all of your pricing is linked to list price, then you only need to enter future prices for the LP record.

When entries other than LP are made in this field, the program:

• displays the currently active list price, if there is no Future Price File LP entry or

• displays the future list price if there is a Future Price File LP record in file.

This ensures that any existing or new formulas entered through the Future Price File display calculated prices, whether or not the list price record is also being changed. For example, if you have two price lists, LP and A1, and the A1 prices are linked to the LP prices then:

• If you enter a Future Price File entry for both of the A1 and LP records of a price class, the future A1 price displays as if linked to the future LP price.

• If you enter a Future Price File entry for only the A1 record of a price class (and not the LP record), then the future A1 price displays linked to the current LP price.

In both examples, the Future Price File program calculates and displays the new prices as they will be updated once the prices are activated. This method is consistent with the Price List programs and how they access the Future Price File.

If your pricing is set up directly in the Item File, and not in the Price File, enter an item number here. The program displays the pricing information for that item record and then you can change it as needed.

Description/Instructions

Current list price in the Price or Item File. You can change this unless the Sub-List Price field is displayed. In that case, you cab change the sub-list, but not the main list price. Remember that many other prices can be linked to the list price.

If you are using Price File records, then the List Price field can only be changed when updating price list LP. All other price lists display the list price, but only allow access to the Sub-List Price field. The prices entered will take effect during the Night Jobs, when the effective date is reached.

Date you want the new prices to take effect in MMDDYY format. If you enter today's date or an earlier date, the new prices will go into effect tonight after the Night Jobs have completed. If new prices are to go into effect on a Monday, and Night Jobs is not scheduled for the weekend, enter Saturday’s date as the effective date. Then, Friday Night Jobs will update the prices.

If you leave this date blank, the system assumes that the new prices go into effect on the effective date and remain active until further notice. If you enter a date here, the new prices go into effect on the effective date, and the old prices are reinstated on the end date. Enter dates in MMDDYY format.

The Price List number column relates to the price list numbers assigned to each customer in the Billto File. In the example, we are using A1, B1, C1 and so on, as shown. An entry in this field indicates the line applies only to customers assigned to that price list number for this product. This field is only displayed when entering by item number.

If you are entering a Price File record, the two-character field TT/Res is displayed. The first character is for transaction type and the second is for restriction code. The transaction type can be one of the following:

• I - This line applies to inventory sales only (sales from stock).

• D - This line applies to direct ship sales only.

• Blank - This price applies to any transaction type.

• The restriction code entry can be one of the following:

• C - For rolled goods, this line applies to cuts only. It is used only when an operator requests a cut price.

• R - For rolled goods, this line applies to rolls only. It is used only when an operator requests a roll price.

• M - For rolled goods, this line is a mid-price (between cut and roll prices). It is used only when an operator enters M.

• M - For any goods, this line is a management approved reduced price. It is used only when an operator enters M.

• Blank - This line has no restrictions. It can be used whether or not operator requests R, C or M.

Only when an order entry operator specifies a restriction code in the R field on their screen does the system look only for a pricing line with that code. For example, if an operator enters C for cut, the system only accepts a price with the restriction code C or with no restriction code.

If an operator checks for a management authorized reduced price by entering code M, the system only accepts a price with the restriction code M or with no restriction code.

Use this field only if you have different unit prices based on quantity. Enter the quantity through which the price applies. An entry of 100 means the price on that line is applicable up to and including 100. If you specify quantity breaks, the last quantity listed should be 99999 as shown in the example.

If you want the application to calculate the price as a percentage of a list price or cost, enter one of the following field codes:

• LP - List Price

• SL - Sub-List Price (displayed only when using Price Files)

• LC - Last Cost (unit cost of last receipt including freight and handling)

• AC - Average Cost (average unit cost of current stock on hand)

• BC - Base Cost (base portion of the current standard cost. It excludes freight and handling.)

• SC - Standard Cost (current standard cost, including freight and handling cost)

• L0 - L9 - Refers to specific prices within the LP price record.

Enter one-character terms code here only if terms are to be overridden when this price is used. Otherwise leave blank. This is applicable only if your system is set for terms by product as opposed to terms by customer.

If you want to calculate the price as a percentage of something else, and you have entered a field code, such as LP, LC, or BC, enter the amount by which to multiply the field.

If you have entered a field code and a variable, the price is calculated automatically, and you should leave this field blank. Otherwise, enter the unit price here.

If you enter a field code representing cost, such as AC or BC, this program might not calculate the price at this time. However, the price is figured at the time of order entry or quoting. This is because some costs are dynamic, and any prices linked to those costs would fluctuate. The costs might also vary depending on the warehouse or shade or lot number of the product.

Leave blank to not round out or enter one of the following codes:

• R - Rounds to the nearest cent value in the standard way. Round down if last digit is 1, 2, 3 or 4. Round up if last digit is 5, 6, 7, 8 or 9.

• U - Rounds the price up to the next cent value.

• D - Rounds the price down to the previous cent value.

• 9 - Rounds to the nearest 9 cents.

• 5 - Rounds to the nearest 5 cents.

This space is reserved for notes or comments about this future pricing record. It is not saved in the Price or Item Files. It is saved in this file only until the future price is activated.

Enter D in this field to delete the Future and Sale Price record. It does not delete the Price File or Item File record. Once a Future Price File is used, and its prices inserted into the actual Price File or Item File record, the system automatically deletes it.

This field is automatically updated and displays the date the record was last changed.

Description

To enter data (similar to pressing Enter) and go to the next record in the file. If you are on a price class entry, press F1 to go to the next record in the Price File. If you are on an item number record, press F1 to go to the next record in the Item File. This is very useful when entering new prices for many consecutive records.

Go to the next record without entering the data on the current screen. If you are on a price class entry, press F2 to go to the next record in the Price File. If you are on an item record, press F2 to go to the next record in the Item File. You can use this key to scan the file, passing records that you do not want to change.

This feature can copy all the future price list records (and formulas) associated with an existing price class to another price class. For example, the price list records LP, A1, B1, B2, etc. can be copied from one price class to another within the Future Price File. This feature is meant to simplify the task of changing your pricing formulas. Once you have entered a set of formulas in the Future Price File, you can use them as a mold to copy to other price classes. For example, price lists A1, B1 and C1 may have represented a 5%, 10%, and 15% discount off list price respectively. If A1, B1, and C1 were changed to represent discounts of 10%, 15%, and 20% then enter one price class with LP, A1, B1 and C1 in the Future Price File with the new price formulas. Then you can enter other price classes with just the LP record, and copy the A1, B1, and C1 automatically applying the new formulas.

This feature does NOT add any new price lists to the Price File. It only updates existing ones. Therefore, regardless of the price lists you enter in the Future Price File, only those that exist in the regular Price File will be updated during the nightly update when the effective dates of the Future Price File records are reached.

End the job and return to the File Maintenance Menu.

Returns to Future and Sale Price Entry screen.

Enter the current record and go to the next price class record for the same price list number. If you are on an LP record, this function key, press F10 to go to the LP record of the next price class. This key applies only when you are working on price class records. If your prices are linked to list price, this key provides the most efficient way for entering multiple changes to list prices.

Go to the next price class record for the same price list number without entering the current record, If you are on an LP record, press F12 to go to the LP record of the next price class. This key applies only when working on price class records.

Although there is no hot key that returns you to this program, you can exit this program by using any of the hot keys that lead directly to the hot key functions.